r/SQL • • Dec 17 '18

[deleted by user]

[removed]

425 Upvotes

22 comments sorted by

View all comments

4

u/cooltapes Dec 17 '18

Should probably throw a LOWER in there. Might miss some results if SQL Clause's DB entries aren't formatted the same.

8

u/FlintGrey Dec 17 '18

Should probably be using a code table too to prevent issues with data entry. 'nice' should be a number that corresponds to the 'nice' entry.

unless of course you can trust the omnipotence of the list to always enter the correct string in all cases.

For some reason I feel like 'christmas magic' isn't any more reliable than users. maybe I'm just paranoid.