使用LIKE获取数据库数据并按顺序排序

Question

I use this code but not work:

$sql =  mysql_query('SELECT etchat_user_id, etchat_username, etchat_userprivilegien , emtiyaz FROM db1_etchat_user WHERE etchat_userprivilegien LIKE "%hhh%" ORDER BY emtiyaz DESC');

Nothing to show. I have very words like hhh in my database but this code don't show anything.

Answer 1

Try reversing your quote usage.

mysql_query
     ("SELECT etchat_user_id, etchat_username, 
      etchat_userprivilegien , 
      emtiyaz FROM db1_etchat_user WHERE 
      etchat_userprivilegien LIKE ('%hhh%') 
      ORDER BY emtiyaz DESC");