Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › Filtering recordset using LIKE failing

Filtering recordset using LIKE failing

Thread began 9/04/2009 11:13 am by Les Crowley | Last modified 9/08/2009 2:39 pm by Les Crowley | 5873 views | 14 replies

9/04/2009 11:27 amtom92909Beta Tester

hmmm that should have worked...

Sprintf might use different syntax than using a straight SELECT statement.

Below works great in PhpMyAdmin ( I just checked to be sure ).

LIKE CONVERT( _utf8 '%s% USING latin1)

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.