This is how i would execute a script without user input. How do i change it to user input.
Expand|Select|Wrap|Line Numbers
- SELECT DISTINCT `MEMBERNO`
- FROM `table`
- WHERE `DATEOFBIRTH` = '1960-06-01'
- AND `FIRSTNAMES` LIKE CONVERT( _utf8 'Name'
- USING latin1 )
- COLLATE latin1_swedish_ci
- AND `SURNAME` LIKE CONVERT( _utf8 'Surname'
- USING latin1 )
- COLLATE latin1_swedish_ci
Can Someone PLEASE HELP