mysql left 字符串截取的数据可以用来在where筛选吗？

码拜

9年 ago

select left (content,1) as abstract ,id from tiku_items_options where item_id = “28606”

本人想这样写
select left (content,1) as abstract ,id from tiku_items_options where item_id = “28606” where abstract = “A”;
但是不行。
问一下一下有什么办法可以筛选吗？

解决方案

select left (content,1) as abstract ,id from tiku_items_options where item_id = “28606” where left (content,1)= “A”;

select left (content,1) as abstract ,id from tiku_items_options where item_id = “28606” where left (content,1) = “A”;