Question

SQL语句模糊查询问题！

use linshiBusiness

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 '%唐萍%'

老是出现列名“唐萍”无效 问题依旧

Answer 1

显然是pi_id也要like '%唐萍%'的!如果不加引号,SQL会认为是一个列名(变量),因为找不到"唐萍"列,所以会报无效!

Answer 2

oracle 正则表达式

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

Answer 3

select * from productInfo where pi_id = "唐萍"

应该加单引号 ‘’

Answer 4

pi_id = "唐萍" 此处用单引号

Answer 5

第一个“唐萍”没加引号