SQL语句模糊查询问题！
select * from productInfo where pi_id = "唐萍" or pi_Process_Num like '%唐萍%' or pi_Checker like '%唐萍%' or pi_Material like '%唐萍%' or pi_Process_Name like '%唐萍%' or pi_Operator like '%唐萍%' or pi_Reprocessed_Reason like '%唐萍%' or pi_Reprocessed_Reason like '%唐萍%' or pi_steate like '%唐萍%'
老是出现列名“唐萍”无效 问题依旧
最新回答
散步的月光
2024-03-16 06:09:29
白首有我共你
2021-02-28 01:15:22
SQL> select sysdate
2 from dual
3 where regexp_like('king george V',
4 '^[a-zA-z]+[ ]+[a-zA-z]+[ ]+[a-zA-z]+$')
5 ;
SYSDATE
-----------
2009-5-20 上
----------------------------------------------
SQL> select sysdate
2 from dual
3 where regexp_like('king george V',
4 '^[a-zA-z]+[ ]+[a-zA-z]+[ ]+[a-zA-z]+$');
SYSDATE
-----------
2009-5-20 上
------------------------------
如果对您有帮助，请记得采纳为满意答案，谢谢！祝您生活愉快！
vaela
青澜饮舟
2022-10-10 10:32:07
应该加单引号 ‘’
等待__经年
2020-12-05 05:37:52
青春很沉默
2023-01-21 15:56:19
热门标签
