MySQL Database LIKE statement help
Posted: Sun Feb 01, 2004 1:04 pm
I'm trying to compare a longer statement with a shorter one. The shorter statement is located in my database while the longer one is acquired from the user.
Here is the statement I am trying to do.
їcode]
SELECT * from SearchEngines WHERE 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)' like UserAgent
ї/code]
UserAgent is the info stored in my database. What is stored there is Mozilla, which is the start of the user entered statement. How could I get this to work?
Thank you!
Here is the statement I am trying to do.
їcode]
SELECT * from SearchEngines WHERE 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)' like UserAgent
ї/code]
UserAgent is the info stored in my database. What is stored there is Mozilla, which is the start of the user entered statement. How could I get this to work?
Thank you!