Skip to content

Instantly share code, notes, and snippets.

@HusseinMorsy

HusseinMorsy/gist:bcad28217d2c2ca4f2a17c124c344e74

Created June 10, 2016 11:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save HusseinMorsy/bcad28217d2c2ca4f2a17c124c344e74 to your computer and use it in GitHub Desktop.
Save HusseinMorsy/bcad28217d2c2ca4f2a17c124c344e74 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
select * from luxair_coupons where coupon_code like 'B080334%';
Liefert
-[ RECORD 1 ]--------------+---------------------------
id | 314
coupon_code | B080334
booking_id | 3319963
created_at | 2016-02-18 14:04:04.029521
updated_at | 2016-02-18 14:04:04.029521
firstname | Daniéle
lastname | MARCUS
num_passengers | 1
outbound_date | 2016-06-11
inbound_date | 2016-06-19
two_way | t
outbound_departure_stop_id | 50
outbound_arrival_stop_id | 81
-[ RECORD 2 ]--------------+---------------------------
id | 315
coupon_code | B080334
booking_id | 3320063
created_at | 2016-02-18 14:34:20.692944
updated_at | 2016-02-18 14:34:20.692944
firstname | DANIELE
lastname | MARCUS
num_passengers | 1
outbound_date | 2016-06-11
inbound_date | 2016-06-19
two_way | t
outbound_departure_stop_id | 50
outbound_arrival_stop_id | 81
-[ RECORD 3 ]--------------+---------------------------
id | 462
coupon_code | B080334_
booking_id | 3557362
created_at | 2016-05-26 14:34:32.557432
updated_at | 2016-05-26 14:34:32.557432
firstname | DANIELE
lastname | MARCUS
num_passengers | 1
outbound_date | 2016-06-11
inbound_date | 2016-06-19
two_way | t
outbound_departure_stop_id | 50
outbound_arrival_stop_id | 81
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment