Re: Using Wild card characters inside command statements

[Peter Brawley]

First. the LIKE operator looks for string matches with wildcards, eg both 'scatter' LIKE '%cat%' and 'cats' LIKE 'cat%' return 1. Is your roomtype variable like that?

Second, LIKE treats digits simply as characters, so '100' is LIKE '1%' but NOT LIKE '101'. Is that what you want from RoomNo LIKE RoomNo?

Third, the effect of GROUP BY will be to return one row per RoomNo, and if there are other Rooms columns, the column values returned will have a random relationship with RoomNo (see GROUP BY in the manual). Is that what you want?

PB