sql server:char index(str, substr, pos)
mysql:INSTR(str, substr)
e.g.
SELECT *
FROM `dp_shop_info`
WHERE (
INSTR
(
name
,
alias
)
!=
0
OR INSTR ( alias , name ) != 0
OR INSTR ( alias , name ) != 0
)
AND alias != ""
sql server:char index(str, substr, pos)
mysql:INSTR(str, substr)
e.g.
SELECT *
FROM `dp_shop_info`
WHERE (
)
AND alias != ""