Shanta McBain <mailto:[EMAIL PROTECTED]>
on Wednesday, October 20, 2004 9:29 AM said:
> [% FOREACH link = DBI.query("SELECT * FROM url_tb
> WHERE products LIKE 'honey'
> AND (site_name = 'Apis' OR
> site_name = 'All')
> ORDER BY link_order
> ")%]
are you saying the products field has data like this in it?
"tacosburritoshoneycrackerscake" ... and you want to search for 'honey'?
do LIKE '%honey%'. but of course this should really be normalized and
split into another table.
chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
