Page 1 of 1

sql troubles

Posted: Sun Jul 24, 2005 9:13 pm
by psychotomus
what seems to be wrong with this?

Code: Select all

SELECT * FROM Test WHERE The_Title LIKE % dog %
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\websites\admin\animemid\www\advance_search.php on line 106
LIKE % dog %

Posted: Sun Jul 24, 2005 10:05 pm
by nyy2000
What's the exact code?

Posted: Sun Jul 24, 2005 10:26 pm
by timvw
http://dev.mysql.com/doc/mysql/en/strin ... tions.html

Code: Select all

SELECT foo
FROM bar
WHERE col LIKE '%bar%'