Posted: Tue Sep 10, 2002 5:39 am
If searching on a field that is an Int then no quotes are required.
select *
from mytable
where myintvalue = $myint
However, you can also use quotes in this query and it will work just as well
select *
from mytable
where myintvalue = '$myint'
If it is a string field type then quotes must be used
select *
from mytable
where mystringvalue = '$mystring'
select *
from mytable
where myintvalue = $myint
However, you can also use quotes in this query and it will work just as well
select *
from mytable
where myintvalue = '$myint'
If it is a string field type then quotes must be used
select *
from mytable
where mystringvalue = '$mystring'