All pastes #36294 Raw Edit

Unnamed

public text v1 · immutable
#36294 ·published 2006-01-09 20:34 UTC
rendered paste body
Query:
SELECT AccountGroup as District FROM customers WHERE Accountgroup Like concat('N4K - MI - ','%') Group by accountgroup Order By Accountgroup

Result:
+---------------------------------+
| District                        |
+---------------------------------+
| N4K - MI - TawasSchool          |
+---------------------------------+


Query:
SELECT AccountGroup as District FROM customers WHERE Accountgroup Like concat('N4K - MI - TawasSchool','%') Group by accountgroup Order By Accountgroup


Result:
Empty Set.