using OR in awk

Question

I use the following two commands to see my tables from binlogs.

mysqlbinlog mysql-bin.000016 | awk '/session/,/;/' | more

mysqlbinlog mysql-bin.000016 | awk '/session_log/,/;/' | more

How do I see both the table lines in a single statement?

Answer 1

I think what you need is:

mysqlbinlog mysql-bin.000016 | awk '/session(_log)?/,/;/' | more

Use '?' to show that '_log' is option so with or without it.