php - 在 mysql select 查询中忽略 #,\,/, uppercase,$

Question

我在下拉列表中填充所有用户名。我想忽略包含任何这些 #, \, /, uppercase, $。我正在执行此查询，但它仍然显示带有 \ 的记录，例如 ad\name。

select account_name from dba_account where CAST(account_name  AS BINARY) RLIKE '[a-z]' 
and account_name not like '%#%' and account_name not like '%$%' and account_name not like 
'%/%' limit 50;

有什么建议吗？？？？

谢谢你...

Answer 1

SELECT
  account_name 
FROM
  dba_account 
WHERE 
  CAST(account_name  AS BINARY) RLIKE '[a-z]' 
  AND account_name NOT RLIKE '[#$\\\\/]'
LIMIT 50;